with open('/datasets/admin_level_geomap.geojson', 'r') as f: geo_json = json.load(f)
category_seats_count
chain_count
chain['name'] = chain['name'].apply(replace_duplicates) #print(chain_top['name'].unique())wrong_values = ['Яндекс.Лавка'] # список неправильных имён correct_value = 'Яндекс Лавка' # правильное имя replace_wrong_values(chain_top, 'name', wrong_values, correct_value) # вызов функции, replace()
data[['category', 'rating']].sort_values(by='rating', ascending=False)for i in rating_mean_name: rating_mean_sort = data[[i, 'rating']]rating_mean_sort
street_category_top = data.groupby(['street', 'category']).agg({'address':'count'}).sort_values(by='address', ascending=False).reset_index().head(15)
street_topdata_street_top = [] for i in street_top['street']: print(i) data_street_top.append(data.loc[(data['name'] == i)])
data.query('rating < 4').groupby('category').agg({'name':'count'}).sort_values(by='name', ascending=False).reset_index()#.sort_values(by='rating').